import sqlite3

mydb = './DB/libSys.db'

def get_conn():
    conn = sqlite3.connect(mydb)
    return conn

# def close_conn(conn)
#     conn.commit()
#     conn.close()

if __name__ == '__main__':
    conn = get_conn()
    cur = conn.cursor()
    sql = 'SELECT author_name FROM author'
    result = cur.execute(sql)
    all_reluts = result.fetchall()
    print(all_reluts)
    conn.close()



